/*
 * bw_dbcol.h
 *
 *  Created on: 2018年9月6日
 *  Author: Degang.Wu (windragon@126.com)
 *  Desc:	数据库以及表的字段定义
 */

#ifndef BW_DBCOL_H_
#define BW_DBCOL_H_

#define DBTBL_USER		"user"	//用户表
#define DBCOL_ID		"id"
#define DBCOL_USERNAME	"username"
#define DBCOL_PASSWORD	"password"

#define DBTBL_CONFIG	"config"	//配置表
#define DBCOL_KEY		"key"
#define DBCOL_VAL		"val"
#define DBCOL_LAST_TIME	"last_time"

#define DBTBL_UUID	"unique_id" // uuid表
#define DBCOL_DES	"des"

#define DBTBL_LOG	"sys_log"	// 日志表
#define DBCOL_TYPE	"type"
#define DBCOL_DETAIL	"detail"
#define DBCOL_TIME	"time"

#define DBTBL_OSD_SET	"osd_set"  // osd表
#define DBCOL_CHL_ID	"chl_id"
#define DBCOL_C_ID	"c_id"

#define DBTBL_OSD_CHL	"osd_chl" // osd_chl表

#define DBCOL_UP_TIME	"up_tm"
#define DBTBL_SUB_SET "sub_set"  // 字幕表
#define DBCOL_VD_FORMAT "vd_format"
#define DBCOL_ROLL_SPEED "roll_speed"

#define DBCOL_LEVEL	"level"
#define DBCOL_DIS_W	"dis_w"
#define DBCOL_DIS_H	"dis_h"
#define DBCOL_P_X	"p_x"
#define DBCOL_P_Y	"p_y"
#define DBCOL_FONT_SIZE "font_size"
#define DBCOL_FONT	"font"
#define DBCOL_FONT_TYPE	"font_type"
#define DBCOL_FONT_COLOR	"font_color"
#define DBCOL_BACK_COLOR	"back_color"
#define DBCOL_CONTENT	"content"

#define DBTBL_LOGO_SET	"logo_set"		// logo表
#define DBCOL_SLIDE_INTERVAL	"slide_interval"
#define DBCOL_OPACITY	"opacity"
#define DBCOL_WIDTH	"width"
#define DBCOL_HEIGHT "height"

#define DBTBL_LOGO_IMG "logo_img"	// logo img表
#define DBCOL_L_ID	"l_id"
#define DBCOL_URL	"url"
#define DBCOL_PATH	"path"
#define DBCOL_CREATE_TIME	"create_tm"

#define DBTBL_QRCODE_SET	"qrcode_set"	// qrcode_set表
#define DBCOL_DIS_X	"dis_x"
#define DBCOL_DIS_Y	"dis_y"
#define DBCOL_TEXT_P	"text_p"
#define DBCOL_TEXT	"text"
#define DBCOL_LOGO_URL "logo_url"
#define DBCOL_IMG_URL "img_url"

#define DBCOL_TEXT_URL	"text_url"


#define DBTBL_OSD_PERIOD	"osd_period"	// osd时间段表
#define DBCOL_OS_ID	"os_id"
#define DBCOL_DAY	"day"
#define DBCOL_START_TIME "start_time"
#define DBCOL_END_TIME	"end_time"
#define DBCOL_STATE	"state"

#define DBCOL_OSD_ID "osd_id"

#endif /* BW_DBCOL_H_ */
